How to Use mysqldump to back up MySQL Data,
MySQL's mysqldump tool supports single-threaded operations. Multiple tables are exported one by one without a parallel machine, which makes it unable to quickly back up data.
Mydumper is a utility that
1 IntroductionMysqldump is the official MySQL Backup tool, is a very useful MySQL data transfer tool, with compatible strong, cross-version and other characteristicsMydumper is a high-performance multi-threaded backup and recovery tool for MySQL
The permission to execute mysqldump is intended to achieve the backup of the entire database by clicking the button on the php page $ tmpname & quot; wholesystem. SQL & quot; unlink ($ setupdirection. & quot; tmp $ tmpname & quot;); $ command & quot;
The permission to execute mysqldump is intended to achieve the backup of the entire database by clicking the button on the php page $ tmpname & quot; wholesystem. SQL & quot; unlink ($ setupdirection. & quot; tmp $ tmpname & quot;); $ command & quot;
MySQL's own mysqldump tool supports single-threaded work, exporting multiple tables in turn, without a parallel machine, which makes it impossible to quickly back up data.
Mydumper, as a utility, can support multithreaded work well, and can read
The permission to execute mysqldump is intended to achieve the backup of the entire database by clicking the button on the php page $ tmpname = & quot; wholesystem. SQL & quot; unlink ($ setupdirection. & quot;/tmp/$ tmpname & quot;); $ comma
Permission issues to perform mysqldump
To make a backup of the entire database by clicking the button on the PHP page
$tmpname = "Wholesystem.sql";
Unlink ($setupdirection. "/tmp/$tmpname");
$command = "Mysqldump--opt--default-character-set=latin1-u
Text: often use the contact MySQL copy function of friends should be not unfamiliar with the mysqldump command, I recently also in the study of this piece of content, after a few days of testing, found that mysqldump use easy to meet a few problems,
Permission issues to perform mysqldump
To make a backup of the entire database by clicking the button on the PHP page
$tmpname = "Wholesystem.sql";
Unlink ($setupdirection. "/tmp/$tmpname");
$command = "Mysqldump--opt--default-character-set=latin1-u
Use mysqldump to regularly back up the database script mysqldump
Script Description
All data is backed up once every 7 days, and binlog is backed up every day, that is, incremental backup.
(If there is little data, you can back up the complete
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.